package com.ktg.mes.unit.demo.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;

public class ApiSetMain {

    private static final long serialVersionUID = 1L;

    /**主键*/
    @TableId(value = "id",type = IdType.AUTO)
    private String id;

    /**创建人*/
    private java.lang.String createBy;


    /**创建日期*/
    private java.util.Date createTime;


    /**更新人*/
    private java.lang.String updateBy;


    /**更新日期*/
    private java.util.Date updateTime;

    private String remark;


    //---------------------------------------------------------- api 接口编程
    //api 接口编码
    private String apiCode;

    //api 接口说明
    private String apiDes;

    //api 数据库源
    private String dsName;

    //数据库查询语句
    private String sqlFind;
    /**
     * [{"sqlOne":" select user_name from sys_user where user_id in ('#{aa}') limit 0"}
     * ,{"sqlList":"select device_name from device where user_name in '#{sql.username}',
     * {"result":"select device_name from device where user_name in '#{sql.username}'"}"},]
     */

    //api 接口 上传参数说明
    private String paramDes; //{"aa":"用户ID","sql.username":"用户名"}

    //返回参数说明
    private String result;
    /**
     * {"userName":{"show":true,"name":“用户名”},{"deviceName":{"show":true,"name":“用户名”}}
     */

    /*
-- Table structure for rec_processes_ext
-- ----------------------------
DROP TABLE IF EXISTS `api_code`;
CREATE TABLE `api_code`  (
  `api_code` bigint NOT NULL AUTO_INCREMENT COMMENT 'api ID',
  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
  `des` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',

   ‘replaceParam‘ JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'api Param 字段转',

  `sql_json` JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据库json [{"dsName":"数据库源","name":"名称","type":"类型","key":["",""],"sql":" select * "},{}]',
  `api_param` JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'api 需要的参数',
  `api_result` JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'api 返回的数据',


  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '界面' ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;

    * */







    //---------------------------------------------------------- 界面编程

    //PDA 界面编程
    private String padTitle;
    private String pdaImageUrl;
    private String padCode; //界面编码
    private String show; //[{"code.name":{}},{"id":{}}}];
    private String type; // 区分表
    private String tableId; //关联表id
    private String tableIdName; //字段名称

    /*
-- Table structure for rec_processes_ext
-- ----------------------------
DROP TABLE IF EXISTS `auto_screen`;
CREATE TABLE `auto_screen`  (
  `screen_code` bigint NOT NULL AUTO_INCREMENT COMMENT '屏幕id',
  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `table_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表类型',
  `table_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表记录id',
  `table_id_Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表记录id的名称',

  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `imageUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题关联的图片',

  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '界面' ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;

    * */

    //---------------------------------------------------------- 界面项记录编程

    //PDA 界面项记录编程,编辑，删除，用过配置界面实现
    private String _type; // 区分表
    private String _tableId; //关联表id
    private String padId; // PDA 界面id
    private String padItemId; //PDA 项ID

    private String padItemTitle;
    private String padItemRequire;
    private String isHidden; //是否隐藏显示
    private String padItemIndex; //排序
    private String padItemType; //项类型  输入框，输入搜索框,跳转界面，弹出框，单选框，查询列表

    private String isCanSelect; //是否能够选择  0 不可选择 多余1就是能够选择的条数
    private String padItemStyle; //项样式，带卡片，列表，背景颜色，边框，字体等
    private String isAutoGetAfter; // 自动请求,当前 padItemApiCode 已经选择，触发当前界面项请求
    private String isAutoSelect; //自动选择 {“res.data”:{"row":"0","优先级":{"key":["a","b"]}}}

    //api 接口 编码code
    private String padItemApiCode;

    //api 接口 上传参数配置
    private String padItemApiParam;

    /**
     * [{"code.name":{"优先级":[""]}},{"id":{}}}];
     */

    //界面调整需要展示的内容
    private String padItemResultShow;
    /**
     * [{"name":{}},{"id":{}}}];
     */

        /*
-- Table structure for rec_processes_ext
-- ----------------------------
DROP TABLE IF EXISTS `auto_screen_item`;
CREATE TABLE `auto_screen_item`  (
  `screen_code_id` bigint NOT NULL AUTO_INCREMENT COMMENT '屏幕项id',
  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `table_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表类型',
  `table_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表记录id',
  `table_id_Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表记录id的名称',

  `screen_code` bigint NOT NULL COMMENT '屏幕id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
  `imageUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题关联的图片',
  `require` int NOT NULL COMMENT '是否必须',
  `hidden` int NOT NULL COMMENT '是否隐藏',
  `show_index` int NOT NULL COMMENT '排序',
  `show_type` int NOT NULL COMMENT '项类型',
  `select_count` int NOT NULL COMMENT '选择数量',
  `style` JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'style',
  'auto_get_after' varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '保存list,在这些请求完成之后，马上自动请求此接口',
  `auto_select` JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '自动选择规则',
  ‘show_result_dic’ JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '根据返回内容展示字典',

  'api_code' varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求此接口',
  `api_param` JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口请求参数，从规则：api_code."key"."0"',
  `api_result_show` JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口请求参数说明，用于选择列表，如排序，展示哪些字段，卡片，还是列表',
  `save_key` JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '选择后的内容用哪个key选择',


  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '界面项' ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;

    * */


    // 上传参数判断配置
    private String _platformCode;
    private String _platformTitle; //名称
    private String _platformParam; //保存后台 参数字段{“字段字段”：“内容字段”}

    /*
-- Table structure for rec_processes_ext
-- ----------------------------
DROP TABLE IF EXISTS `auto_screen_parameter`;
CREATE TABLE `auto_screen_parameter`  (
  `auto_screen_parameter_id` bigint NOT NULL AUTO_INCREMENT COMMENT '参数id',
  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',


  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `param` JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数字段{“字段字段”：“内容字段”}',

  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '界面项参数判断需要类型配置' ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;

    * */

    //---------------------------------------------------------- //后台界面编程

    //api 参数需要那些值
    private String platformCode;
    private String platformTitle; //名称
    private String platformParam; //保存后台 参数字段{“字段字段”：“内容字段”}
    /*
-- Table structure for rec_processes_ext
-- ----------------------------
DROP TABLE IF EXISTS `auto_screen_parameter_value`;
CREATE TABLE `auto_screen_parameter_value`  (
  `auto_screen_parameter_id` bigint NOT NULL AUTO_INCREMENT COMMENT '参数id',
  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',

  `table_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表类型使用',
  `table_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表记录id使用',
  `table_id_Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表记录id的名称',

  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `param_value` JSON CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数字段{“字段字段”：“内容字段”}',

  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '界面项参数判断需要类型配置' ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;

    * */


    //api 保存参数值规则
    private String __type; // 区分表
    private String __tableId; //关联表id
    private String __padCode; //界面编码
    private String __platformParamValue; //保存后台 参数字段{“字段字段”：“内容字段”}



}
